SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwePosiblesVacantes
AS
SELECT     IdVacante AS ID, Localidad, CargoGenerico, AsignaturaGenerica, Convocatoria
FROM         dbo.tb_PosiblesVacantes
GO
GRANT SELECT ON  [dbo].[vwePosiblesVacantes] TO [Juntas]
GRANT INSERT ON  [dbo].[vwePosiblesVacantes] TO [Juntas]
GRANT DELETE ON  [dbo].[vwePosiblesVacantes] TO [Juntas]
GRANT UPDATE ON  [dbo].[vwePosiblesVacantes] TO [Juntas]
GRANT SELECT ON  [dbo].[vwePosiblesVacantes] TO [SoloVer]
GO
